BEGIN;

UPDATE C_City SET C_Region_ID=200109 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='37375263-310e-4d02-8898-2a816b325c38') AND C_Region_ID!=200109;

UPDATE C_Location SET C_Region_ID=200109 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='37375263-310e-4d02-8898-2a816b325c38') AND C_Region_ID!=200109;

UPDATE C_Tax SET C_Region_ID=200109 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='37375263-310e-4d02-8898-2a816b325c38') AND C_Region_ID!=200109;

UPDATE I_BPartner SET C_Region_ID=200109 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='37375263-310e-4d02-8898-2a816b325c38') AND C_Region_ID!=200109;

UPDATE C_Region_Trl SET C_Region_ID=200109 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='37375263-310e-4d02-8898-2a816b325c38') AND C_Region_ID!=200109;

UPDATE C_Region SET C_Region_ID=200109 WHERE C_Region_UU='37375263-310e-4d02-8898-2a816b325c38' AND C_Region_ID!=200109;

UPDATE C_City SET C_Region_ID=200110 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e34f6000-5511-4027-8e1e-3b697569520f') AND C_Region_ID!=200110;

UPDATE C_Location SET C_Region_ID=200110 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e34f6000-5511-4027-8e1e-3b697569520f') AND C_Region_ID!=200110;

UPDATE C_Tax SET C_Region_ID=200110 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e34f6000-5511-4027-8e1e-3b697569520f') AND C_Region_ID!=200110;

UPDATE I_BPartner SET C_Region_ID=200110 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e34f6000-5511-4027-8e1e-3b697569520f') AND C_Region_ID!=200110;

UPDATE C_Region_Trl SET C_Region_ID=200110 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e34f6000-5511-4027-8e1e-3b697569520f') AND C_Region_ID!=200110;

UPDATE C_Region SET C_Region_ID=200110 WHERE C_Region_UU='e34f6000-5511-4027-8e1e-3b697569520f' AND C_Region_ID!=200110;

UPDATE C_City SET C_Region_ID=200111 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='eda02e6d-0ff6-4f40-9073-4d9a0e7c7cd1') AND C_Region_ID!=200111;

UPDATE C_Location SET C_Region_ID=200111 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='eda02e6d-0ff6-4f40-9073-4d9a0e7c7cd1') AND C_Region_ID!=200111;

UPDATE C_Tax SET C_Region_ID=200111 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='eda02e6d-0ff6-4f40-9073-4d9a0e7c7cd1') AND C_Region_ID!=200111;

UPDATE I_BPartner SET C_Region_ID=200111 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='eda02e6d-0ff6-4f40-9073-4d9a0e7c7cd1') AND C_Region_ID!=200111;

UPDATE C_Region_Trl SET C_Region_ID=200111 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='eda02e6d-0ff6-4f40-9073-4d9a0e7c7cd1') AND C_Region_ID!=200111;

UPDATE C_Region SET C_Region_ID=200111 WHERE C_Region_UU='eda02e6d-0ff6-4f40-9073-4d9a0e7c7cd1' AND C_Region_ID!=200111;

UPDATE C_City SET C_Region_ID=200112 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='296ca964-4037-419d-8680-003dab587c74') AND C_Region_ID!=200112;

UPDATE C_Location SET C_Region_ID=200112 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='296ca964-4037-419d-8680-003dab587c74') AND C_Region_ID!=200112;

UPDATE C_Tax SET C_Region_ID=200112 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='296ca964-4037-419d-8680-003dab587c74') AND C_Region_ID!=200112;

UPDATE I_BPartner SET C_Region_ID=200112 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='296ca964-4037-419d-8680-003dab587c74') AND C_Region_ID!=200112;

UPDATE C_Region_Trl SET C_Region_ID=200112 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='296ca964-4037-419d-8680-003dab587c74') AND C_Region_ID!=200112;

UPDATE C_Region SET C_Region_ID=200112 WHERE C_Region_UU='296ca964-4037-419d-8680-003dab587c74' AND C_Region_ID!=200112;

UPDATE C_City SET C_Region_ID=200113 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d3361c61-1e78-4899-9281-06b80670c25d') AND C_Region_ID!=200113;

UPDATE C_Location SET C_Region_ID=200113 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d3361c61-1e78-4899-9281-06b80670c25d') AND C_Region_ID!=200113;

UPDATE C_Tax SET C_Region_ID=200113 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d3361c61-1e78-4899-9281-06b80670c25d') AND C_Region_ID!=200113;

UPDATE I_BPartner SET C_Region_ID=200113 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d3361c61-1e78-4899-9281-06b80670c25d') AND C_Region_ID!=200113;

UPDATE C_Region_Trl SET C_Region_ID=200113 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d3361c61-1e78-4899-9281-06b80670c25d') AND C_Region_ID!=200113;

UPDATE C_Region SET C_Region_ID=200113 WHERE C_Region_UU='d3361c61-1e78-4899-9281-06b80670c25d' AND C_Region_ID!=200113;

UPDATE C_City SET C_Region_ID=200114 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fc89a575-3b4b-49c2-8d43-b92ecc9fae69') AND C_Region_ID!=200114;

UPDATE C_Location SET C_Region_ID=200114 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fc89a575-3b4b-49c2-8d43-b92ecc9fae69') AND C_Region_ID!=200114;

UPDATE C_Tax SET C_Region_ID=200114 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fc89a575-3b4b-49c2-8d43-b92ecc9fae69') AND C_Region_ID!=200114;

UPDATE I_BPartner SET C_Region_ID=200114 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fc89a575-3b4b-49c2-8d43-b92ecc9fae69') AND C_Region_ID!=200114;

UPDATE C_Region_Trl SET C_Region_ID=200114 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fc89a575-3b4b-49c2-8d43-b92ecc9fae69') AND C_Region_ID!=200114;

UPDATE C_Region SET C_Region_ID=200114 WHERE C_Region_UU='fc89a575-3b4b-49c2-8d43-b92ecc9fae69' AND C_Region_ID!=200114;

UPDATE C_City SET C_Region_ID=200115 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fd10aa38-9b97-4a4d-af2b-8b8493101c6c') AND C_Region_ID!=200115;

UPDATE C_Location SET C_Region_ID=200115 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fd10aa38-9b97-4a4d-af2b-8b8493101c6c') AND C_Region_ID!=200115;

UPDATE C_Tax SET C_Region_ID=200115 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fd10aa38-9b97-4a4d-af2b-8b8493101c6c') AND C_Region_ID!=200115;

UPDATE I_BPartner SET C_Region_ID=200115 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fd10aa38-9b97-4a4d-af2b-8b8493101c6c') AND C_Region_ID!=200115;

UPDATE C_Region_Trl SET C_Region_ID=200115 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='fd10aa38-9b97-4a4d-af2b-8b8493101c6c') AND C_Region_ID!=200115;

UPDATE C_Region SET C_Region_ID=200115 WHERE C_Region_UU='fd10aa38-9b97-4a4d-af2b-8b8493101c6c' AND C_Region_ID!=200115;

UPDATE C_City SET C_Region_ID=200116 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d73f44bc-2a0a-4241-a7df-4f953b7541df') AND C_Region_ID!=200116;

UPDATE C_Location SET C_Region_ID=200116 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d73f44bc-2a0a-4241-a7df-4f953b7541df') AND C_Region_ID!=200116;

UPDATE C_Tax SET C_Region_ID=200116 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d73f44bc-2a0a-4241-a7df-4f953b7541df') AND C_Region_ID!=200116;

UPDATE I_BPartner SET C_Region_ID=200116 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d73f44bc-2a0a-4241-a7df-4f953b7541df') AND C_Region_ID!=200116;

UPDATE C_Region_Trl SET C_Region_ID=200116 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d73f44bc-2a0a-4241-a7df-4f953b7541df') AND C_Region_ID!=200116;

UPDATE C_Region SET C_Region_ID=200116 WHERE C_Region_UU='d73f44bc-2a0a-4241-a7df-4f953b7541df' AND C_Region_ID!=200116;

UPDATE C_City SET C_Region_ID=200117 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='c4e51844-76f9-4334-9c9c-b3c1b2863641') AND C_Region_ID!=200117;

UPDATE C_Location SET C_Region_ID=200117 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='c4e51844-76f9-4334-9c9c-b3c1b2863641') AND C_Region_ID!=200117;

UPDATE C_Tax SET C_Region_ID=200117 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='c4e51844-76f9-4334-9c9c-b3c1b2863641') AND C_Region_ID!=200117;

UPDATE I_BPartner SET C_Region_ID=200117 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='c4e51844-76f9-4334-9c9c-b3c1b2863641') AND C_Region_ID!=200117;

UPDATE C_Region_Trl SET C_Region_ID=200117 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='c4e51844-76f9-4334-9c9c-b3c1b2863641') AND C_Region_ID!=200117;

UPDATE C_Region SET C_Region_ID=200117 WHERE C_Region_UU='c4e51844-76f9-4334-9c9c-b3c1b2863641' AND C_Region_ID!=200117;

UPDATE C_City SET C_Region_ID=200118 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af5c45f8-6dae-405d-bcd6-fc625af97645') AND C_Region_ID!=200118;

UPDATE C_Location SET C_Region_ID=200118 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af5c45f8-6dae-405d-bcd6-fc625af97645') AND C_Region_ID!=200118;

UPDATE C_Tax SET C_Region_ID=200118 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af5c45f8-6dae-405d-bcd6-fc625af97645') AND C_Region_ID!=200118;

UPDATE I_BPartner SET C_Region_ID=200118 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af5c45f8-6dae-405d-bcd6-fc625af97645') AND C_Region_ID!=200118;

UPDATE C_Region_Trl SET C_Region_ID=200118 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af5c45f8-6dae-405d-bcd6-fc625af97645') AND C_Region_ID!=200118;

UPDATE C_Region SET C_Region_ID=200118 WHERE C_Region_UU='af5c45f8-6dae-405d-bcd6-fc625af97645' AND C_Region_ID!=200118;

UPDATE C_City SET C_Region_ID=200119 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='f1a4ea81-c52c-4861-87c3-ac9f576b9025') AND C_Region_ID!=200119;

UPDATE C_Location SET C_Region_ID=200119 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='f1a4ea81-c52c-4861-87c3-ac9f576b9025') AND C_Region_ID!=200119;

UPDATE C_Tax SET C_Region_ID=200119 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='f1a4ea81-c52c-4861-87c3-ac9f576b9025') AND C_Region_ID!=200119;

UPDATE I_BPartner SET C_Region_ID=200119 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='f1a4ea81-c52c-4861-87c3-ac9f576b9025') AND C_Region_ID!=200119;

UPDATE C_Region_Trl SET C_Region_ID=200119 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='f1a4ea81-c52c-4861-87c3-ac9f576b9025') AND C_Region_ID!=200119;

UPDATE C_Region SET C_Region_ID=200119 WHERE C_Region_UU='f1a4ea81-c52c-4861-87c3-ac9f576b9025' AND C_Region_ID!=200119;

UPDATE C_City SET C_Region_ID=200120 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='76942396-3fee-4968-b7ab-34da5b0ce1e4') AND C_Region_ID!=200120;

UPDATE C_Location SET C_Region_ID=200120 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='76942396-3fee-4968-b7ab-34da5b0ce1e4') AND C_Region_ID!=200120;

UPDATE C_Tax SET C_Region_ID=200120 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='76942396-3fee-4968-b7ab-34da5b0ce1e4') AND C_Region_ID!=200120;

UPDATE I_BPartner SET C_Region_ID=200120 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='76942396-3fee-4968-b7ab-34da5b0ce1e4') AND C_Region_ID!=200120;

UPDATE C_Region_Trl SET C_Region_ID=200120 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='76942396-3fee-4968-b7ab-34da5b0ce1e4') AND C_Region_ID!=200120;

UPDATE C_Region SET C_Region_ID=200120 WHERE C_Region_UU='76942396-3fee-4968-b7ab-34da5b0ce1e4' AND C_Region_ID!=200120;

UPDATE C_City SET C_Region_ID=200121 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d6837959-4eea-492a-9682-1c147f565001') AND C_Region_ID!=200121;

UPDATE C_Location SET C_Region_ID=200121 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d6837959-4eea-492a-9682-1c147f565001') AND C_Region_ID!=200121;

UPDATE C_Tax SET C_Region_ID=200121 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d6837959-4eea-492a-9682-1c147f565001') AND C_Region_ID!=200121;

UPDATE I_BPartner SET C_Region_ID=200121 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d6837959-4eea-492a-9682-1c147f565001') AND C_Region_ID!=200121;

UPDATE C_Region_Trl SET C_Region_ID=200121 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='d6837959-4eea-492a-9682-1c147f565001') AND C_Region_ID!=200121;

UPDATE C_Region SET C_Region_ID=200121 WHERE C_Region_UU='d6837959-4eea-492a-9682-1c147f565001' AND C_Region_ID!=200121;

UPDATE C_City SET C_Region_ID=200122 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='68f64691-e6ee-4751-aab9-3ac8fd09bab8') AND C_Region_ID!=200122;

UPDATE C_Location SET C_Region_ID=200122 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='68f64691-e6ee-4751-aab9-3ac8fd09bab8') AND C_Region_ID!=200122;

UPDATE C_Tax SET C_Region_ID=200122 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='68f64691-e6ee-4751-aab9-3ac8fd09bab8') AND C_Region_ID!=200122;

UPDATE I_BPartner SET C_Region_ID=200122 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='68f64691-e6ee-4751-aab9-3ac8fd09bab8') AND C_Region_ID!=200122;

UPDATE C_Region_Trl SET C_Region_ID=200122 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='68f64691-e6ee-4751-aab9-3ac8fd09bab8') AND C_Region_ID!=200122;

UPDATE C_Region SET C_Region_ID=200122 WHERE C_Region_UU='68f64691-e6ee-4751-aab9-3ac8fd09bab8' AND C_Region_ID!=200122;

UPDATE C_City SET C_Region_ID=200123 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='67717ed1-eb80-4a39-8d6d-d4fb7e8bf4f0') AND C_Region_ID!=200123;

UPDATE C_Location SET C_Region_ID=200123 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='67717ed1-eb80-4a39-8d6d-d4fb7e8bf4f0') AND C_Region_ID!=200123;

UPDATE C_Tax SET C_Region_ID=200123 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='67717ed1-eb80-4a39-8d6d-d4fb7e8bf4f0') AND C_Region_ID!=200123;

UPDATE I_BPartner SET C_Region_ID=200123 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='67717ed1-eb80-4a39-8d6d-d4fb7e8bf4f0') AND C_Region_ID!=200123;

UPDATE C_Region_Trl SET C_Region_ID=200123 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='67717ed1-eb80-4a39-8d6d-d4fb7e8bf4f0') AND C_Region_ID!=200123;

UPDATE C_Region SET C_Region_ID=200123 WHERE C_Region_UU='67717ed1-eb80-4a39-8d6d-d4fb7e8bf4f0' AND C_Region_ID!=200123;

UPDATE C_City SET C_Region_ID=200124 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a14dadca-8cad-4afa-9b63-05020874b89f') AND C_Region_ID!=200124;

UPDATE C_Location SET C_Region_ID=200124 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a14dadca-8cad-4afa-9b63-05020874b89f') AND C_Region_ID!=200124;

UPDATE C_Tax SET C_Region_ID=200124 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a14dadca-8cad-4afa-9b63-05020874b89f') AND C_Region_ID!=200124;

UPDATE I_BPartner SET C_Region_ID=200124 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a14dadca-8cad-4afa-9b63-05020874b89f') AND C_Region_ID!=200124;

UPDATE C_Region_Trl SET C_Region_ID=200124 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a14dadca-8cad-4afa-9b63-05020874b89f') AND C_Region_ID!=200124;

UPDATE C_Region SET C_Region_ID=200124 WHERE C_Region_UU='a14dadca-8cad-4afa-9b63-05020874b89f' AND C_Region_ID!=200124;

UPDATE C_City SET C_Region_ID=200125 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='0f101b83-c041-4d9c-9351-ad71d9a09fe0') AND C_Region_ID!=200125;

UPDATE C_Location SET C_Region_ID=200125 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='0f101b83-c041-4d9c-9351-ad71d9a09fe0') AND C_Region_ID!=200125;

UPDATE C_Tax SET C_Region_ID=200125 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='0f101b83-c041-4d9c-9351-ad71d9a09fe0') AND C_Region_ID!=200125;

UPDATE I_BPartner SET C_Region_ID=200125 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='0f101b83-c041-4d9c-9351-ad71d9a09fe0') AND C_Region_ID!=200125;

UPDATE C_Region_Trl SET C_Region_ID=200125 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='0f101b83-c041-4d9c-9351-ad71d9a09fe0') AND C_Region_ID!=200125;

UPDATE C_Region SET C_Region_ID=200125 WHERE C_Region_UU='0f101b83-c041-4d9c-9351-ad71d9a09fe0' AND C_Region_ID!=200125;

UPDATE C_City SET C_Region_ID=200126 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='21782e7c-e79e-40be-b7e1-ca5fff2406df') AND C_Region_ID!=200126;

UPDATE C_Location SET C_Region_ID=200126 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='21782e7c-e79e-40be-b7e1-ca5fff2406df') AND C_Region_ID!=200126;

UPDATE C_Tax SET C_Region_ID=200126 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='21782e7c-e79e-40be-b7e1-ca5fff2406df') AND C_Region_ID!=200126;

UPDATE I_BPartner SET C_Region_ID=200126 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='21782e7c-e79e-40be-b7e1-ca5fff2406df') AND C_Region_ID!=200126;

UPDATE C_Region_Trl SET C_Region_ID=200126 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='21782e7c-e79e-40be-b7e1-ca5fff2406df') AND C_Region_ID!=200126;

UPDATE C_Region SET C_Region_ID=200126 WHERE C_Region_UU='21782e7c-e79e-40be-b7e1-ca5fff2406df' AND C_Region_ID!=200126;

UPDATE C_City SET C_Region_ID=200127 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1cfa1f8e-56bd-4284-86ef-d541681fd93c') AND C_Region_ID!=200127;

UPDATE C_Location SET C_Region_ID=200127 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1cfa1f8e-56bd-4284-86ef-d541681fd93c') AND C_Region_ID!=200127;

UPDATE C_Tax SET C_Region_ID=200127 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1cfa1f8e-56bd-4284-86ef-d541681fd93c') AND C_Region_ID!=200127;

UPDATE I_BPartner SET C_Region_ID=200127 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1cfa1f8e-56bd-4284-86ef-d541681fd93c') AND C_Region_ID!=200127;

UPDATE C_Region_Trl SET C_Region_ID=200127 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1cfa1f8e-56bd-4284-86ef-d541681fd93c') AND C_Region_ID!=200127;

UPDATE C_Region SET C_Region_ID=200127 WHERE C_Region_UU='1cfa1f8e-56bd-4284-86ef-d541681fd93c' AND C_Region_ID!=200127;

UPDATE C_City SET C_Region_ID=200128 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='436807e8-70c7-49ac-9531-0344ac724b50') AND C_Region_ID!=200128;

UPDATE C_Location SET C_Region_ID=200128 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='436807e8-70c7-49ac-9531-0344ac724b50') AND C_Region_ID!=200128;

UPDATE C_Tax SET C_Region_ID=200128 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='436807e8-70c7-49ac-9531-0344ac724b50') AND C_Region_ID!=200128;

UPDATE I_BPartner SET C_Region_ID=200128 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='436807e8-70c7-49ac-9531-0344ac724b50') AND C_Region_ID!=200128;

UPDATE C_Region_Trl SET C_Region_ID=200128 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='436807e8-70c7-49ac-9531-0344ac724b50') AND C_Region_ID!=200128;

UPDATE C_Region SET C_Region_ID=200128 WHERE C_Region_UU='436807e8-70c7-49ac-9531-0344ac724b50' AND C_Region_ID!=200128;

UPDATE C_City SET C_Region_ID=200129 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='04ba142c-c430-4716-ae33-9a19c5df4434') AND C_Region_ID!=200129;

UPDATE C_Location SET C_Region_ID=200129 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='04ba142c-c430-4716-ae33-9a19c5df4434') AND C_Region_ID!=200129;

UPDATE C_Tax SET C_Region_ID=200129 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='04ba142c-c430-4716-ae33-9a19c5df4434') AND C_Region_ID!=200129;

UPDATE I_BPartner SET C_Region_ID=200129 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='04ba142c-c430-4716-ae33-9a19c5df4434') AND C_Region_ID!=200129;

UPDATE C_Region_Trl SET C_Region_ID=200129 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='04ba142c-c430-4716-ae33-9a19c5df4434') AND C_Region_ID!=200129;

UPDATE C_Region SET C_Region_ID=200129 WHERE C_Region_UU='04ba142c-c430-4716-ae33-9a19c5df4434' AND C_Region_ID!=200129;

UPDATE C_City SET C_Region_ID=200130 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='deee0c36-ba46-4423-92fa-73c38983a6f1') AND C_Region_ID!=200130;

UPDATE C_Location SET C_Region_ID=200130 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='deee0c36-ba46-4423-92fa-73c38983a6f1') AND C_Region_ID!=200130;

UPDATE C_Tax SET C_Region_ID=200130 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='deee0c36-ba46-4423-92fa-73c38983a6f1') AND C_Region_ID!=200130;

UPDATE I_BPartner SET C_Region_ID=200130 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='deee0c36-ba46-4423-92fa-73c38983a6f1') AND C_Region_ID!=200130;

UPDATE C_Region_Trl SET C_Region_ID=200130 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='deee0c36-ba46-4423-92fa-73c38983a6f1') AND C_Region_ID!=200130;

UPDATE C_Region SET C_Region_ID=200130 WHERE C_Region_UU='deee0c36-ba46-4423-92fa-73c38983a6f1' AND C_Region_ID!=200130;

UPDATE C_City SET C_Region_ID=200131 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a36c60d0-d472-4cd8-b55a-646cb701db0c') AND C_Region_ID!=200131;

UPDATE C_Location SET C_Region_ID=200131 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a36c60d0-d472-4cd8-b55a-646cb701db0c') AND C_Region_ID!=200131;

UPDATE C_Tax SET C_Region_ID=200131 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a36c60d0-d472-4cd8-b55a-646cb701db0c') AND C_Region_ID!=200131;

UPDATE I_BPartner SET C_Region_ID=200131 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a36c60d0-d472-4cd8-b55a-646cb701db0c') AND C_Region_ID!=200131;

UPDATE C_Region_Trl SET C_Region_ID=200131 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a36c60d0-d472-4cd8-b55a-646cb701db0c') AND C_Region_ID!=200131;

UPDATE C_Region SET C_Region_ID=200131 WHERE C_Region_UU='a36c60d0-d472-4cd8-b55a-646cb701db0c' AND C_Region_ID!=200131;

UPDATE C_City SET C_Region_ID=200132 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c73c3ec-1777-4b6a-85bf-adc020ef8296') AND C_Region_ID!=200132;

UPDATE C_Location SET C_Region_ID=200132 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c73c3ec-1777-4b6a-85bf-adc020ef8296') AND C_Region_ID!=200132;

UPDATE C_Tax SET C_Region_ID=200132 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c73c3ec-1777-4b6a-85bf-adc020ef8296') AND C_Region_ID!=200132;

UPDATE I_BPartner SET C_Region_ID=200132 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c73c3ec-1777-4b6a-85bf-adc020ef8296') AND C_Region_ID!=200132;

UPDATE C_Region_Trl SET C_Region_ID=200132 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c73c3ec-1777-4b6a-85bf-adc020ef8296') AND C_Region_ID!=200132;

UPDATE C_Region SET C_Region_ID=200132 WHERE C_Region_UU='8c73c3ec-1777-4b6a-85bf-adc020ef8296' AND C_Region_ID!=200132;

UPDATE C_City SET C_Region_ID=200133 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a06f94e6-79be-4f30-b0e7-4b89ee772128') AND C_Region_ID!=200133;

UPDATE C_Location SET C_Region_ID=200133 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a06f94e6-79be-4f30-b0e7-4b89ee772128') AND C_Region_ID!=200133;

UPDATE C_Tax SET C_Region_ID=200133 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a06f94e6-79be-4f30-b0e7-4b89ee772128') AND C_Region_ID!=200133;

UPDATE I_BPartner SET C_Region_ID=200133 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a06f94e6-79be-4f30-b0e7-4b89ee772128') AND C_Region_ID!=200133;

UPDATE C_Region_Trl SET C_Region_ID=200133 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a06f94e6-79be-4f30-b0e7-4b89ee772128') AND C_Region_ID!=200133;

UPDATE C_Region SET C_Region_ID=200133 WHERE C_Region_UU='a06f94e6-79be-4f30-b0e7-4b89ee772128' AND C_Region_ID!=200133;

UPDATE C_City SET C_Region_ID=200134 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e707706d-ed1c-4949-a261-f9d3cf46a9f9') AND C_Region_ID!=200134;

UPDATE C_Location SET C_Region_ID=200134 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e707706d-ed1c-4949-a261-f9d3cf46a9f9') AND C_Region_ID!=200134;

UPDATE C_Tax SET C_Region_ID=200134 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e707706d-ed1c-4949-a261-f9d3cf46a9f9') AND C_Region_ID!=200134;

UPDATE I_BPartner SET C_Region_ID=200134 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e707706d-ed1c-4949-a261-f9d3cf46a9f9') AND C_Region_ID!=200134;

UPDATE C_Region_Trl SET C_Region_ID=200134 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='e707706d-ed1c-4949-a261-f9d3cf46a9f9') AND C_Region_ID!=200134;

UPDATE C_Region SET C_Region_ID=200134 WHERE C_Region_UU='e707706d-ed1c-4949-a261-f9d3cf46a9f9' AND C_Region_ID!=200134;

UPDATE C_City SET C_Region_ID=200135 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='64dcf5ef-78be-44bd-a08e-652d75eda922') AND C_Region_ID!=200135;

UPDATE C_Location SET C_Region_ID=200135 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='64dcf5ef-78be-44bd-a08e-652d75eda922') AND C_Region_ID!=200135;

UPDATE C_Tax SET C_Region_ID=200135 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='64dcf5ef-78be-44bd-a08e-652d75eda922') AND C_Region_ID!=200135;

UPDATE I_BPartner SET C_Region_ID=200135 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='64dcf5ef-78be-44bd-a08e-652d75eda922') AND C_Region_ID!=200135;

UPDATE C_Region_Trl SET C_Region_ID=200135 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='64dcf5ef-78be-44bd-a08e-652d75eda922') AND C_Region_ID!=200135;

UPDATE C_Region SET C_Region_ID=200135 WHERE C_Region_UU='64dcf5ef-78be-44bd-a08e-652d75eda922' AND C_Region_ID!=200135;

UPDATE C_City SET C_Region_ID=200136 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='3bca93ee-a8e9-45f3-bc44-779765e5d6d8') AND C_Region_ID!=200136;

UPDATE C_Location SET C_Region_ID=200136 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='3bca93ee-a8e9-45f3-bc44-779765e5d6d8') AND C_Region_ID!=200136;

UPDATE C_Tax SET C_Region_ID=200136 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='3bca93ee-a8e9-45f3-bc44-779765e5d6d8') AND C_Region_ID!=200136;

UPDATE I_BPartner SET C_Region_ID=200136 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='3bca93ee-a8e9-45f3-bc44-779765e5d6d8') AND C_Region_ID!=200136;

UPDATE C_Region_Trl SET C_Region_ID=200136 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='3bca93ee-a8e9-45f3-bc44-779765e5d6d8') AND C_Region_ID!=200136;

UPDATE C_Region SET C_Region_ID=200136 WHERE C_Region_UU='3bca93ee-a8e9-45f3-bc44-779765e5d6d8' AND C_Region_ID!=200136;

UPDATE C_City SET C_Region_ID=200137 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c3da3cc-9b16-4b1e-aafc-f06b5bdea8d5') AND C_Region_ID!=200137;

UPDATE C_Location SET C_Region_ID=200137 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c3da3cc-9b16-4b1e-aafc-f06b5bdea8d5') AND C_Region_ID!=200137;

UPDATE C_Tax SET C_Region_ID=200137 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c3da3cc-9b16-4b1e-aafc-f06b5bdea8d5') AND C_Region_ID!=200137;

UPDATE I_BPartner SET C_Region_ID=200137 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c3da3cc-9b16-4b1e-aafc-f06b5bdea8d5') AND C_Region_ID!=200137;

UPDATE C_Region_Trl SET C_Region_ID=200137 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='8c3da3cc-9b16-4b1e-aafc-f06b5bdea8d5') AND C_Region_ID!=200137;

UPDATE C_Region SET C_Region_ID=200137 WHERE C_Region_UU='8c3da3cc-9b16-4b1e-aafc-f06b5bdea8d5' AND C_Region_ID!=200137;

UPDATE C_City SET C_Region_ID=200138 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a1804300-649b-42e7-94cc-16dd3f96783e') AND C_Region_ID!=200138;

UPDATE C_Location SET C_Region_ID=200138 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a1804300-649b-42e7-94cc-16dd3f96783e') AND C_Region_ID!=200138;

UPDATE C_Tax SET C_Region_ID=200138 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a1804300-649b-42e7-94cc-16dd3f96783e') AND C_Region_ID!=200138;

UPDATE I_BPartner SET C_Region_ID=200138 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a1804300-649b-42e7-94cc-16dd3f96783e') AND C_Region_ID!=200138;

UPDATE C_Region_Trl SET C_Region_ID=200138 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='a1804300-649b-42e7-94cc-16dd3f96783e') AND C_Region_ID!=200138;

UPDATE C_Region SET C_Region_ID=200138 WHERE C_Region_UU='a1804300-649b-42e7-94cc-16dd3f96783e' AND C_Region_ID!=200138;

UPDATE C_City SET C_Region_ID=200139 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af2ada76-13e4-476c-a1ad-698fec933a79') AND C_Region_ID!=200139;

UPDATE C_Location SET C_Region_ID=200139 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af2ada76-13e4-476c-a1ad-698fec933a79') AND C_Region_ID!=200139;

UPDATE C_Tax SET C_Region_ID=200139 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af2ada76-13e4-476c-a1ad-698fec933a79') AND C_Region_ID!=200139;

UPDATE I_BPartner SET C_Region_ID=200139 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af2ada76-13e4-476c-a1ad-698fec933a79') AND C_Region_ID!=200139;

UPDATE C_Region_Trl SET C_Region_ID=200139 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='af2ada76-13e4-476c-a1ad-698fec933a79') AND C_Region_ID!=200139;

UPDATE C_Region SET C_Region_ID=200139 WHERE C_Region_UU='af2ada76-13e4-476c-a1ad-698fec933a79' AND C_Region_ID!=200139;

UPDATE C_City SET C_Region_ID=200140 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='74e8e4d6-9aca-4399-a057-9e5b27e63ec1') AND C_Region_ID!=200140;

UPDATE C_Location SET C_Region_ID=200140 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='74e8e4d6-9aca-4399-a057-9e5b27e63ec1') AND C_Region_ID!=200140;

UPDATE C_Tax SET C_Region_ID=200140 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='74e8e4d6-9aca-4399-a057-9e5b27e63ec1') AND C_Region_ID!=200140;

UPDATE I_BPartner SET C_Region_ID=200140 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='74e8e4d6-9aca-4399-a057-9e5b27e63ec1') AND C_Region_ID!=200140;

UPDATE C_Region_Trl SET C_Region_ID=200140 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='74e8e4d6-9aca-4399-a057-9e5b27e63ec1') AND C_Region_ID!=200140;

UPDATE C_Region SET C_Region_ID=200140 WHERE C_Region_UU='74e8e4d6-9aca-4399-a057-9e5b27e63ec1' AND C_Region_ID!=200140;

UPDATE C_City SET C_Region_ID=200141 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1d2c330b-b712-44e3-adea-568519f02356') AND C_Region_ID!=200141;

UPDATE C_Location SET C_Region_ID=200141 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1d2c330b-b712-44e3-adea-568519f02356') AND C_Region_ID!=200141;

UPDATE C_Tax SET C_Region_ID=200141 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1d2c330b-b712-44e3-adea-568519f02356') AND C_Region_ID!=200141;

UPDATE I_BPartner SET C_Region_ID=200141 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1d2c330b-b712-44e3-adea-568519f02356') AND C_Region_ID!=200141;

UPDATE C_Region_Trl SET C_Region_ID=200141 WHERE C_Region_ID=(SELECT C_Region_ID FROM C_Region WHERE C_Region_UU='1d2c330b-b712-44e3-adea-568519f02356') AND C_Region_ID!=200141;

UPDATE C_Region SET C_Region_ID=200141 WHERE C_Region_UU='1d2c330b-b712-44e3-adea-568519f02356' AND C_Region_ID!=200141;

COMMIT;

